Water of Leith

What is it like to live in Water of Leith?